﻿CREATE TABLE [dbo].[Account]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Account] NVARCHAR(50) NOT NULL, 
    [Passport] NCHAR(24) NULL, 
    [Enable] BIT NOT NULL DEFAULT 1
)

GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'帐号名',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Account',
    @level2type = N'COLUMN',
    @level2name = 'Account'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'密码24位',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Account',
    @level2type = N'COLUMN',
    @level2name = N'Passport'
GO
EXEC sp_addextendedproperty @name = N'MS_Description',
    @value = N'启用帐号',
    @level0type = N'SCHEMA',
    @level0name = N'dbo',
    @level1type = N'TABLE',
    @level1name = N'Account',
    @level2type = N'COLUMN',
    @level2name = N'Enable'